<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

/**
 * Class CreateMedicalAuxiliarycheckTable
 * 辅助检查数据库
 */
class CreateMedicalAuxiliarycheckTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('st_medical_auxiliarycheck', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedInteger('record_id')->index()->comment("关联medical_records_id");
            $table->text('blood')->nullable()->comment("血糖检查情况");
            $table->text('insulin')->nullable()->comment("胰岛素检查情况");
            $table->text('peptide_c')->nullable()->comment("C肽检查情况");
            $table->text('ogtt')->nullable()->comment("OGTT检查情况");
            $table->text('saccharify')->nullable()->comment("糖化检查情况");
            $table->text('diabetes_antibody')->nullable()->comment("1型糖尿病相关抗体检查情况");
            $table->text('acr')->nullable()->comment("ACR检查情况");
            $table->text('uaer')->nullable()->comment("8h尿蛋白排泄率检查情况");
            $table->text('urine_routine')->nullable()->comment("尿常规检查情况");
            $table->text('biochemical_examination')->nullable()->comment("生化全项检查情况");
            $table->text('liver_function')->nullable()->comment("肝功检查情况");
            $table->text('kidney')->nullable()->comment("肾全检查情况");
            $table->text('electrolyte')->nullable()->comment("电解质检查情况");
            $table->text('tg_chohdlldl')->nullable()->comment("血脂四项检查情况");
            $table->text('bt_paba')->nullable()->comment("胰功检查情况");
            $table->text('thyroid_function_one')->nullable()->comment("甲功1检查情况");
            $table->text('thyroid_function_two')->nullable()->comment("甲功2检查情况");
            $table->text('thyroid_function_three')->nullable()->comment("甲功3检查情况");
            $table->text('plasma_acth')->nullable()->comment("血浆ACTH检查情况");
            $table->text('blood_cortisol')->nullable()->comment("血总皮质醇检查情况");
            $table->text('endocrine_examination')->nullable()->comment("内分泌六项检查情况");
            $table->text('growth_hormone')->nullable()->comment("生长激素检查情况");
            $table->text('insulin_growth_factor')->nullable()->comment("胰岛素样生长因子检查情况");
            $table->text('blood_routine')->nullable()->comment("血常规检查情况");
            $table->text('blood_gas_analysis')->nullable()->comment("血气分析检查情况");
            $table->text('blood_coagulation_two')->nullable()->comment("凝血2检查情况");
            $table->text('dexamethasone_suppression')->nullable()->comment("地塞米松抑制试验检查情况");
            $table->text('hydroxyvitamin')->nullable()->comment("25羟维生素D3检查情况");
            $table->text('uca_up')->nullable()->comment("24h尿钙（U-Ca）+24h尿磷（U-P）检查情况");
            $table->text('collagen_degradation')->nullable()->comment("β-胶原降解产物测定检查情况");
            $table->text('iconography')->nullable()->comment("影像学检查 检查情况");
            $table->string('remark')->default('')->comment('备注');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('st_medical_auxiliarycheck');
    }
}
